EPF Wages = Basic + DA (from salary components). As per EPFO illustration: new wage ceiling ₹25,000, effective 17.09.2026 (period 1: 1–16 Sep, period 2: 17–30 Sep)
Scenario
Columns: Name, UAN, Gross Wages, EPF Wages (Basic + DA) (calculation uses EPF Wages, i.e. Basic + DA). Optional extra columns: Scenario (A/B/C, overrides the selection per row), NCP Days, Refund of Advances (default 0).
Result
Method: "EPF Wages" input = Basic + DA. EPF wage = Period1 + Period2 wages. Employee 12% of EPF wage; EPS 8.33% of EPS wage; Employer EPF = Employee 12% − EPS; EDLI 0.5% (EPF wage, max ₹25,000); Admin 0.5% of EPF wage. Period 1 wage: A = 0, B = wage×16/30, C = min(wage,15000)×16/30. Period 2 wage = min(wage,25000)×14/30. EPS wage: A = Period 2, B = Period 2 only, C = Period 1 + 2. Verify against your EPFO guidelines before filing.